﻿<?xml version="1.0" encoding="utf-8"?>
<Database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="AugData">
  <Schema Name="dbo" Property="dbo" Class="Dbo">
    <Table Name="EventAgenda" Property="EventAgendas">
      <Column Name="EventAgendaId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="Speaker" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="SecondSpeaker" Type="System.String" DbType="NVarChar(100)" StringLength="100" />
      <Column Name="Starting" Type="System.DateTime" DbType="SmallDateTime" Nullable="true" />
      <Column Name="Ending" Type="System.DateTime" DbType="SmallDateTime" Nullable="true" />
      <Column Name="LevelId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="Summary" Type="System.String" DbType="NVarChar(300) NOT NULL" Nullable="false" StringLength="300" />
      <Column Name="EventId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_EventAgenda_Event" Property="Event" Kind="ManyToOneParent" Target="Event">
        <Column Name="EventId" />
      </Association>
      <Association Name="FK_EventAgenda_EventArticleLevel" Property="EventArticleLevel" Kind="ManyToOneParent" Target="EventArticleLevel">
        <Column Name="LevelId" />
      </Association>
      <PrimaryKey Name="PK_EventAgenda">
        <Column Name="EventAgendaId" />
      </PrimaryKey>
      <Index Name="PK_EventAgenda" Style="CLUSTERED" IsUnique="true">
        <Column Name="EventAgendaId" />
      </Index>
    </Table>
    <Table Name="BookCategory" Property="BookCategories">
      <Column Name="BookCategoryId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="Description" Type="System.String" DbType="NChar(200)" StringLength="200" />
      <Association Name="FK_Book_BookCategory" Property="Books" Kind="ManyToOneChild" Target="Book">
        <Column Name="BookCategoryId" />
      </Association>
      <PrimaryKey Name="PK_BookCategory">
        <Column Name="BookCategoryId" />
      </PrimaryKey>
      <Index Name="PK_BookCategory" Style="CLUSTERED" IsUnique="true">
        <Column Name="BookCategoryId" />
      </Index>
    </Table>
    <Table Name="aspnet_WebEvent_Events" Property="AspnetWebEventEvents" Class="AspnetWebEventEvent">
      <Column Name="EventId" Type="System.String" DbType="Char(32) NOT NULL" Nullable="false" IsIdentity="true" StringLength="32" />
      <Column Name="EventTimeUtc" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="EventTime" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="EventType" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="EventSequence" Type="System.Decimal" DbType="Decimal(19,0) NOT NULL" Precision="19" Scale="0" />
      <Column Name="EventOccurrence" Type="System.Decimal" DbType="Decimal(19,0) NOT NULL" Precision="19" Scale="0" />
      <Column Name="EventCode" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="EventDetailCode" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="Message" Type="System.String" DbType="NVarChar(1024)" StringLength="1024" />
      <Column Name="ApplicationPath" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Column Name="ApplicationVirtualPath" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Column Name="MachineName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="RequestUrl" Type="System.String" DbType="NVarChar(1024)" StringLength="1024" />
      <Column Name="ExceptionType" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Column Name="Details" Type="System.String" DbType="NText" UpdateCheck="Never" StringLength="1073741823" />
      <PrimaryKey Name="PK__aspnet_WebEvent___07C12930">
        <Column Name="EventId" />
      </PrimaryKey>
      <Index Name="PK__aspnet_WebEvent___07C12930" Style="CLUSTERED" IsUnique="true">
        <Column Name="EventId" />
      </Index>
    </Table>
    <Table Name="JobOffer" Property="JobOffers">
      <Column Name="JobOfferId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="CompanyId" Type="System.String" DbType="NChar(10)" StringLength="10" />
      <Column Name="Company" Type="System.String" DbType="NVarChar(200) NOT NULL" Nullable="false" StringLength="200" />
      <Column Name="Date" Type="System.DateTime" DbType="SmallDateTime NOT NULL" />
      <Column Name="Position" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(500) NOT NULL" Nullable="false" StringLength="500" />
      <Column Name="Qualifications" Type="System.String" DbType="NVarChar(200)" StringLength="200" />
      <Column Name="Schedule" Type="System.String" DbType="NVarChar(50)" StringLength="50" />
      <Column Name="SalaryMin" Type="System.Decimal" DbType="Money" Nullable="true" Precision="19" Scale="255" />
      <Column Name="SalaryMax" Type="System.Decimal" DbType="Money" Nullable="true" Precision="19" Scale="255" />
      <Column Name="ContactPerson" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="ContactPhoneNumber" Type="System.String" DbType="NVarChar(50)" StringLength="50" />
      <Column Name="ContactEmail" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="IsOpen" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="SubmittedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_JobOffer_aspnet_Users" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="SubmittedByUserId" />
      </Association>
      <Association Name="FK_JobOffer_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupId" />
      </Association>
      <PrimaryKey Name="PK_JobOffer">
        <Column Name="JobOfferId" />
      </PrimaryKey>
      <Index Name="PK_JobOffer" Style="CLUSTERED" IsUnique="true">
        <Column Name="JobOfferId" />
      </Index>
    </Table>
    <Table Name="Resource" Property="Resources">
      <Column Name="ResourceId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(500) NOT NULL" Nullable="false" StringLength="500" />
      <Column Name="Date" Type="System.DateTime" DbType="SmallDateTime NOT NULL" />
      <Column Name="Uri" Type="System.String" DbType="VarChar(255)" StringLength="255" />
      <Column Name="IsVisible" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="Size" Type="System.Int32" DbType="Int" Nullable="true" Precision="10" Scale="255" />
      <Column Name="IsPublic" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="IsLink" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="IsFile" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="SubmittedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_Resource_aspnet_Users" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="SubmittedByUserId" />
      </Association>
      <Association Name="FK_Resource_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupId" />
      </Association>
      <PrimaryKey Name="PK_Resource">
        <Column Name="ResourceId" />
      </PrimaryKey>
      <Index Name="PK_Resource" Style="CLUSTERED" IsUnique="true">
        <Column Name="ResourceId" />
      </Index>
    </Table>
    <Table Name="Country" Property="Countries">
      <Column Name="CountryId" Type="System.Int16" DbType="SmallInt NOT NULL" IsIdentity="true" Precision="5" Scale="255" />
      <Column Name="Country" Property="Content" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="A2" Type="System.String" DbType="Char(2) NOT NULL" Nullable="false" StringLength="2" />
      <Column Name="A3" Type="System.String" DbType="Char(3) NOT NULL" Nullable="false" StringLength="3" />
      <Association Name="FK_UserDetail_Country" Property="UserDetails" Kind="ManyToOneChild" Target="UserDetail">
        <Column Name="CountryId" />
      </Association>
      <PrimaryKey Name="PK_Country">
        <Column Name="CountryId" />
      </PrimaryKey>
      <Index Name="PK_Country" Style="CLUSTERED" IsUnique="true">
        <Column Name="CountryId" />
      </Index>
    </Table>
    <Table Name="Company" Property="Companies">
      <Column Name="CompanyId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="Homepage" Type="System.String" DbType="VarChar(200)" StringLength="200" />
      <Column Name="ContactPerson" Type="System.String" DbType="NVarChar(50)" StringLength="50" />
      <Column Name="ContactPhoneNumber" Type="System.String" DbType="NVarChar(30)" StringLength="30" />
      <Column Name="ContactEmail" Type="System.String" DbType="NVarChar(80)" StringLength="80" />
      <Column Name="IsVisible" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="SubmittedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_Company_aspnet_Users" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="SubmittedByUserId" />
      </Association>
      <Association Name="FK_Company_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupId" />
      </Association>
      <PrimaryKey Name="PK_Company">
        <Column Name="CompanyId" />
      </PrimaryKey>
      <Index Name="PK_Company" Style="CLUSTERED" IsUnique="true">
        <Column Name="CompanyId" />
      </Index>
    </Table>
    <Table Name="BookStatus" Class="BookStatu">
      <Column Name="BookStatusId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(20) NOT NULL" Nullable="false" StringLength="20" />
      <Association Name="FK_Book_BookStatus" Property="Books" Kind="ManyToOneChild" Target="Book">
        <Column Name="BookStatusId" />
      </Association>
      <PrimaryKey Name="PK_BookStatus">
        <Column Name="BookStatusId" />
      </PrimaryKey>
      <Index Name="PK_BookStatus" Style="CLUSTERED" IsUnique="true">
        <Column Name="BookStatusId" />
      </Index>
    </Table>
    <Table Name="Book" Property="Books">
      <Column Name="BookId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="ISBN" Type="System.String" DbType="VarChar(30)" StringLength="30" />
      <Column Name="Author" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="CategoryId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="StatusId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_Book_BookCategory" Property="BookCategory" Kind="ManyToOneParent" Target="BookCategory">
        <Column Name="CategoryId" />
      </Association>
      <Association Name="FK_Book_BookStatus" Property="BookStatu" Kind="ManyToOneParent" Target="BookStatus">
        <Column Name="StatusId" />
      </Association>
      <Association Name="FK_Book_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_BookLoan_Book" Property="BookLoans" Kind="ManyToOneChild" Target="BookLoan">
        <Column Name="BookId" />
      </Association>
      <PrimaryKey Name="PK_Book">
        <Column Name="BookId" />
      </PrimaryKey>
      <Index Name="PK_Book" Style="CLUSTERED" IsUnique="true">
        <Column Name="BookId" />
      </Index>
    </Table>
    <Table Name="aspnet_Applications" Property="AspnetApplications" Class="AspnetApplication">
      <Column Name="ApplicationName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="LoweredApplicationName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Association Name="FK__aspnet_Me__Appli__3C69FB99" Property="AspnetMemberships" Kind="ManyToOneChild" Target="aspnet_Membership">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Pa__Appli__6E01572D" Property="AspnetPaths" Kind="ManyToOneChild" Target="aspnet_Paths">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Ro__Appli__5AEE82B9" Property="AspnetRoles" Kind="ManyToOneChild" Target="aspnet_Roles">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Us__Appli__2C3393D0" Property="AspnetUsers" Kind="ManyToOneChild" Target="aspnet_Users">
        <Column Name="ApplicationId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Applicati__267ABA7A">
        <Column Name="ApplicationId" />
      </PrimaryKey>
      <Index Name="aspnet_Applications_Index" Style="CLUSTERED">
        <Column Name="LoweredApplicationName" />
      </Index>
      <Index Name="PK__aspnet_Applicati__267ABA7A" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="ApplicationId" />
      </Index>
      <Index Name="UQ__aspnet_Applicati__276EDEB3" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="LoweredApplicationName" />
      </Index>
      <Index Name="UQ__aspnet_Applicati__286302EC" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="ApplicationName" />
      </Index>
    </Table>
    <Table Name="BookLoan" Property="BookLoans">
      <Column Name="BookLoanId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="BookId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="ExitDate" Type="System.DateTime" DbType="SmallDateTime" Nullable="true" />
      <Column Name="EntryDate" Type="System.DateTime" DbType="SmallDateTime" Nullable="true" />
      <Column Name="ConditionId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Association Name="FK_BookLoan_aspnet_Users" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_BookLoan_Book" Property="Book" Kind="ManyToOneParent" Target="Book">
        <Column Name="BookId" />
      </Association>
      <Association Name="FK_BookLoan_BookCondition" Property="BookCondition" Kind="ManyToOneParent" Target="BookCondition">
        <Column Name="ConditionId" />
      </Association>
      <PrimaryKey Name="PK_BookLoan">
        <Column Name="BookLoanId" />
      </PrimaryKey>
      <Index Name="PK_BookLoan" Style="CLUSTERED" IsUnique="true">
        <Column Name="BookLoanId" />
      </Index>
    </Table>
    <Table Name="aspnet_Users" Property="AspnetUsers" Class="AspnetUser">
      <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="UserName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="LoweredUserName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="MobileAlias" Type="System.String" DbType="NVarChar(16)" StringLength="16" />
      <Column Name="IsAnonymous" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="LastActivityDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Association Name="FK__aspnet_Me__UserI__3D5E1FD2" Property="AspnetMembership" Kind="OneToOneChild" Target="aspnet_Membership">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK__aspnet_Pe__UserI__787EE5A0" Property="AspnetPersonalizationPerUsers" Kind="ManyToOneChild" Target="aspnet_PersonalizationPerUser">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK__aspnet_Pr__UserI__5165187F" Property="AspnetProfile" Kind="OneToOneChild" Target="aspnet_Profile">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK__aspnet_Us__Appli__2C3393D0" Property="AspnetApplication" Kind="ManyToOneParent" Target="aspnet_Applications">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Us__UserI__5EBF139D" Property="AspnetUsersInRoles" Kind="ManyToOneChild" Target="aspnet_UsersInRoles">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_Article_aspnet_Users" Property="Articles" Kind="ManyToOneChild" Target="Article">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_BookLoan_aspnet_Users" Property="BookLoans" Kind="ManyToOneChild" Target="BookLoan">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_Company_aspnet_Users" Property="Companies" Kind="ManyToOneChild" Target="Company">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_Event_aspnet_Users" Property="Events" Kind="ManyToOneChild" Target="Event">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_JobOffer_aspnet_Users" Property="JobOffers" Kind="ManyToOneChild" Target="JobOffer">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_Resource_aspnet_Users" Property="Resources" Kind="ManyToOneChild" Target="Resource">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_UserDetail_aspnet_Users" Property="UserDetail" Kind="OneToOneChild" Target="UserDetail">
        <Column Name="UserId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Users__2B3F6F97">
        <Column Name="UserId" />
      </PrimaryKey>
      <Index Name="aspnet_Users_Index" Style="CLUSTERED" IsUnique="true">
        <Column Name="ApplicationId" />
        <Column Name="LoweredUserName" />
      </Index>
      <Index Name="PK__aspnet_Users__2B3F6F97" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="UserId" />
      </Index>
      <Index Name="aspnet_Users_Index2" Style="NONCLUSTERED">
        <Column Name="ApplicationId" />
        <Column Name="LastActivityDate" />
      </Index>
    </Table>
    <Table Name="UserDetail" Property="UserDetails">
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="NameFirst" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="NameLast" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="SecondaryEmail" Type="System.String" DbType="NVarChar(200)" StringLength="200" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(200)" StringLength="200" />
      <Column Name="City" Type="System.String" DbType="NVarChar(100)" StringLength="100" />
      <Column Name="State" Type="System.String" DbType="NVarChar(100)" StringLength="100" />
      <Column Name="PostCode" Type="System.String" DbType="NVarChar(20)" StringLength="20" />
      <Column Name="CountryId" Type="System.Int16" DbType="SmallInt NOT NULL" Precision="5" Scale="255" />
      <Column Name="Telephone" Type="System.String" DbType="NVarChar(20)" StringLength="20" />
      <Column Name="CellPhone" Type="System.String" DbType="NVarChar(20)" StringLength="20" />
      <Column Name="SkypeIdent" Type="System.String" DbType="VarChar(20)" StringLength="20" />
      <Column Name="MSNIdent" Type="System.String" DbType="VarChar(20)" StringLength="20" />
      <Column Name="YahooIdent" Type="System.String" DbType="VarChar(20)" StringLength="20" />
      <Column Name="HomePage" Type="System.String" DbType="VarChar(200)" StringLength="200" />
      <Column Name="IsPublic" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="Bio" Type="System.String" DbType="NVarChar(500)" StringLength="500" />
      <Column Name="GroupID" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_UserDetail_aspnet_Users" Property="AspnetUser" Kind="OneToOneParent" Target="aspnet_Users">
        <Column Name="UserId" />
      </Association>
      <Association Name="FK_UserDetail_Country" Property="Country" Kind="ManyToOneParent" Target="Country">
        <Column Name="CountryId" />
      </Association>
      <Association Name="FK_UserDetail_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupID" />
      </Association>
      <PrimaryKey Name="PK_UserDetail_1">
        <Column Name="UserId" />
      </PrimaryKey>
      <Index Name="PK_UserDetail_1" Style="CLUSTERED" IsUnique="true">
        <Column Name="UserId" />
      </Index>
    </Table>
    <Table Name="Article" Property="Articles">
      <Column Name="ArticleId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="CategoryId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="Date" Type="System.DateTime" DbType="SmallDateTime NOT NULL" />
      <Column Name="LevelId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(200) NOT NULL" Nullable="false" StringLength="200" />
      <Column Name="Summary" Type="System.String" DbType="NVarChar(500) NOT NULL" Nullable="false" StringLength="500" />
      <Column Name="IsVisible" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="Views" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="AverageRating" Type="System.Decimal" DbType="Decimal(2,2)" Nullable="true" Precision="2" Scale="2" />
      <Column Name="SubmittedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_Article_Article" Property="ArticleArticle" Kind="OneToOneParent" Target="Article">
        <Column Name="ArticleId" />
      </Association>
      <Association Name="FK_Article_Article" Property="Article0" Kind="OneToOneChild" Target="Article">
        <Column Name="ArticleId" />
      </Association>
      <Association Name="FK_Article_ArticleCategory" Property="ArticleCategory" Kind="ManyToOneParent" Target="ArticleCategory">
        <Column Name="CategoryId" />
      </Association>
      <Association Name="FK_Article_aspnet_Users" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="SubmittedByUserId" />
      </Association>
      <Association Name="FK_Article_EventArticleLevel" Property="EventArticleLevel" Kind="ManyToOneParent" Target="EventArticleLevel">
        <Column Name="LevelId" />
      </Association>
      <Association Name="FK_Article_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_ArticleAttachment_Article" Property="ArticleAttachments" Kind="ManyToOneChild" Target="ArticleAttachment">
        <Column Name="ArticleId" />
      </Association>
      <PrimaryKey Name="PK_Article">
        <Column Name="ArticleId" />
      </PrimaryKey>
      <Index Name="PK_Article" Style="CLUSTERED" IsUnique="true">
        <Column Name="ArticleId" />
      </Index>
    </Table>
    <Table Name="aspnet_SchemaVersions" Property="AspnetSchemaVersions" Class="AspnetSchemaVersion">
      <Column Name="Feature" Type="System.String" DbType="NVarChar(128) NOT NULL" Nullable="false" IsIdentity="true" StringLength="128" />
      <Column Name="CompatibleSchemaVersion" Type="System.String" DbType="NVarChar(128) NOT NULL" Nullable="false" IsIdentity="true" StringLength="128" />
      <Column Name="IsCurrentVersion" Type="System.Boolean" DbType="Bit NOT NULL" />
      <PrimaryKey Name="PK__aspnet_SchemaVer__30F848ED">
        <Column Name="Feature" />
        <Column Name="CompatibleSchemaVersion" />
      </PrimaryKey>
      <Index Name="PK__aspnet_SchemaVer__30F848ED" Style="CLUSTERED" IsUnique="true">
        <Column Name="Feature" />
        <Column Name="CompatibleSchemaVersion" />
      </Index>
    </Table>
    <Table Name="ArticleAttachment" Property="ArticleAttachments">
      <Column Name="ArticleAttachmentId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="ArticleId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="Size" Type="System.Int32" DbType="Int" Nullable="true" Precision="10" Scale="255" />
      <Column Name="Uri" Type="System.String" DbType="VarChar(200)" StringLength="200" />
      <Association Name="FK_ArticleAttachment_Article" Property="Article" Kind="ManyToOneParent" Target="Article">
        <Column Name="ArticleId" />
      </Association>
      <PrimaryKey Name="PK_ArticleAttachment">
        <Column Name="ArticleAttachmentId" />
      </PrimaryKey>
      <Index Name="PK_ArticleAttachment" Style="CLUSTERED" IsUnique="true">
        <Column Name="ArticleAttachmentId" />
      </Index>
    </Table>
    <Table Name="aspnet_Membership" Property="AspnetMemberships" Class="AspnetMembership">
      <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="Password" Type="System.String" DbType="NVarChar(128) NOT NULL" Nullable="false" StringLength="128" />
      <Column Name="PasswordFormat" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="PasswordSalt" Type="System.String" DbType="NVarChar(128) NOT NULL" Nullable="false" StringLength="128" />
      <Column Name="MobilePIN" Type="System.String" DbType="NVarChar(16)" StringLength="16" />
      <Column Name="Email" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Column Name="LoweredEmail" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Column Name="PasswordQuestion" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Column Name="PasswordAnswer" Type="System.String" DbType="NVarChar(128)" StringLength="128" />
      <Column Name="IsApproved" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="IsLockedOut" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="CreateDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="LastLoginDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="LastPasswordChangedDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="LastLockoutDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="FailedPasswordAttemptCount" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="FailedPasswordAttemptWindowStart" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="FailedPasswordAnswerAttemptCount" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="FailedPasswordAnswerAttemptWindowStart" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Column Name="Comment" Type="System.String" DbType="NText" UpdateCheck="Never" StringLength="1073741823" />
      <Association Name="FK__aspnet_Me__Appli__3C69FB99" Property="AspnetApplication" Kind="ManyToOneParent" Target="aspnet_Applications">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Me__UserI__3D5E1FD2" Property="AspnetUser" Kind="OneToOneParent" Target="aspnet_Users">
        <Column Name="UserId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Membershi__3B75D760">
        <Column Name="UserId" />
      </PrimaryKey>
      <Index Name="aspnet_Membership_index" Style="CLUSTERED">
        <Column Name="ApplicationId" />
        <Column Name="LoweredEmail" />
      </Index>
      <Index Name="PK__aspnet_Membershi__3B75D760" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="UserId" />
      </Index>
    </Table>
    <Table Name="EventLocation" Property="EventLocations">
      <Column Name="EventLocationId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="IsOnsite" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="Location" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(200) NOT NULL" Nullable="false" StringLength="200" />
      <Column Name="City" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="State" Type="System.String" DbType="NVarChar(50)" StringLength="50" />
      <Column Name="PostCode" Type="System.String" DbType="NVarChar(20) NOT NULL" Nullable="false" StringLength="20" />
      <Column Name="PhoneNumber" Type="System.String" DbType="VarChar(30)" StringLength="30" />
      <Column Name="ContactPerson" Type="System.String" DbType="NVarChar(80)" StringLength="80" />
      <Association Name="FK_Event_EventLocation" Property="Events" Kind="ManyToOneChild" Target="Event">
        <Column Name="EventLocationId" />
      </Association>
      <PrimaryKey Name="PK_EventLocation">
        <Column Name="EventLocationId" />
      </PrimaryKey>
      <Index Name="PK_EventLocation" Style="CLUSTERED" IsUnique="true">
        <Column Name="EventLocationId" />
      </Index>
    </Table>
    <Table Name="Event" Property="Events">
      <Column Name="EventId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Date" Type="System.DateTime" DbType="SmallDateTime NOT NULL" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(100) NOT NULL" Nullable="false" StringLength="100" />
      <Column Name="EntryFee" Type="System.Decimal" DbType="Money" Nullable="true" Precision="19" Scale="255" />
      <Column Name="RegistrationUri" Type="System.String" DbType="VarChar(250)" StringLength="250" />
      <Column Name="RegistrationCode" Type="System.String" DbType="VarChar(50)" StringLength="50" />
      <Column Name="RegistrationPhoneNumber" Type="System.String" DbType="VarChar(30)" StringLength="30" />
      <Column Name="IsVisible" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Column Name="LocationId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="SubmittedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="OrganizedBy" Type="System.String" DbType="NVarChar(100)" StringLength="100" />
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Association Name="FK_Event_aspnet_Users" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="SubmittedByUserId" />
      </Association>
      <Association Name="FK_Event_EventLocation" Property="EventLocation" Kind="ManyToOneParent" Target="EventLocation">
        <Column Name="LocationId" />
      </Association>
      <Association Name="FK_Event_Group" Property="Group" Kind="ManyToOneParent" Target="Group">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_EventAgenda_Event" Property="EventAgendas" Kind="ManyToOneChild" Target="EventAgenda">
        <Column Name="EventId" />
      </Association>
      <PrimaryKey Name="PK_Event">
        <Column Name="EventId" />
      </PrimaryKey>
      <Index Name="PK_Event" Style="CLUSTERED" IsUnique="true">
        <Column Name="EventId" />
      </Index>
    </Table>
    <Table Name="ArticleCategory" Property="ArticleCategories">
      <Column Name="ArticleCategoryId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(200)" StringLength="200" />
      <Association Name="FK_Article_ArticleCategory" Property="Articles" Kind="ManyToOneChild" Target="Article">
        <Column Name="ArticleCategoryId" />
      </Association>
      <PrimaryKey Name="PK_ArticleCategory">
        <Column Name="ArticleCategoryId" />
      </PrimaryKey>
      <Index Name="PK_ArticleCategory" Style="CLUSTERED" IsUnique="true">
        <Column Name="ArticleCategoryId" />
      </Index>
    </Table>
    <Table Name="BookCondition" Property="BookConditions">
      <Column Name="BookConditionId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Condition" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Association Name="FK_BookLoan_BookCondition" Property="BookLoans" Kind="ManyToOneChild" Target="BookLoan">
        <Column Name="BookConditionId" />
      </Association>
      <PrimaryKey Name="PK_BookCondition">
        <Column Name="BookConditionId" />
      </PrimaryKey>
      <Index Name="PK_BookCondition" Style="CLUSTERED" IsUnique="true">
        <Column Name="BookConditionId" />
      </Index>
    </Table>
    <Table Name="aspnet_Profile" Property="AspnetProfiles" Class="AspnetProfile">
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="PropertyNames" Type="System.String" DbType="NText NOT NULL" Nullable="false" UpdateCheck="Never" StringLength="1073741823" />
      <Column Name="PropertyValuesString" Type="System.String" DbType="NText NOT NULL" Nullable="false" UpdateCheck="Never" StringLength="1073741823" />
      <Column Name="PropertyValuesBinary" Type="System.Byte[]" DbType="Image NOT NULL" Nullable="false" UpdateCheck="Never" />
      <Column Name="LastUpdatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Association Name="FK__aspnet_Pr__UserI__5165187F" Property="AspnetUser" Kind="OneToOneParent" Target="aspnet_Users">
        <Column Name="UserId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Profile__5070F446">
        <Column Name="UserId" />
      </PrimaryKey>
      <Index Name="PK__aspnet_Profile__5070F446" Style="CLUSTERED" IsUnique="true">
        <Column Name="UserId" />
      </Index>
    </Table>
    <Table Name="sysdiagrams" Property="Sysdiagrams" Class="Sysdiagram">
      <Column Name="name" Property="Name" Type="System.String" DbType="NVarChar(128) NOT NULL" Nullable="false" StringLength="128" />
      <Column Name="principal_id" Property="PrincipalId" Type="System.Int32" DbType="Int NOT NULL" Precision="10" Scale="255" />
      <Column Name="diagram_id" Property="DiagramId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="version" Property="Version" Type="System.Int32" DbType="Int" Nullable="true" Precision="10" Scale="255" />
      <Column Name="definition" Property="Definition" Type="System.Byte[]" DbType="VarBinary(2147483647)" UpdateCheck="Never" />
      <PrimaryKey Name="PK__sysdiagrams__5224328E">
        <Column Name="diagram_id" />
      </PrimaryKey>
      <Index Name="PK__sysdiagrams__5224328E" Style="CLUSTERED" IsUnique="true">
        <Column Name="diagram_id" />
      </Index>
      <Index Name="UK_principal_name" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="principal_id" />
        <Column Name="name" />
      </Index>
    </Table>
    <Table Name="aspnet_Roles" Property="AspnetRoles" Class="AspnetRoles">
      <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="RoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="LoweredRoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(256)" StringLength="256" />
      <Association Name="FK__aspnet_Ro__Appli__5AEE82B9" Property="AspnetApplication" Kind="ManyToOneParent" Target="aspnet_Applications">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Us__RoleI__5FB337D6" Property="AspnetUsersInRoles" Kind="ManyToOneChild" Target="aspnet_UsersInRoles">
        <Column Name="RoleId" />
      </Association>
      <Association Name="FK_RoleHasPermission_aspnet_Roles" Property="RoleHasPermissions" Kind="ManyToOneChild" Target="RoleHasPermission">
        <Column Name="RoleId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Roles__59FA5E80">
        <Column Name="RoleId" />
      </PrimaryKey>
      <Index Name="aspnet_Roles_index1" Style="CLUSTERED" IsUnique="true">
        <Column Name="ApplicationId" />
        <Column Name="LoweredRoleName" />
      </Index>
      <Index Name="PK__aspnet_Roles__59FA5E80" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="RoleId" />
      </Index>
    </Table>
    <Table Name="aspnet_UsersInRoles" Property="AspnetUsersInRoles" Class="AspnetUsersInRoles">
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Association Name="FK__aspnet_Us__RoleI__5FB337D6" Property="AspnetRoles" Kind="ManyToOneParent" Target="aspnet_Roles">
        <Column Name="RoleId" />
      </Association>
      <Association Name="FK__aspnet_Us__UserI__5EBF139D" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="UserId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_UsersInRo__5DCAEF64">
        <Column Name="UserId" />
        <Column Name="RoleId" />
      </PrimaryKey>
      <Index Name="PK__aspnet_UsersInRo__5DCAEF64" Style="CLUSTERED" IsUnique="true">
        <Column Name="UserId" />
        <Column Name="RoleId" />
      </Index>
      <Index Name="aspnet_UsersInRoles_index" Style="NONCLUSTERED">
        <Column Name="RoleId" />
      </Index>
    </Table>
    <Table Name="Permission" Property="Permissions">
      <Column Name="PermissionId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(100)" StringLength="100" />
      <Column Name="IsActive" Type="System.Boolean" DbType="Bit NOT NULL" />
      <Association Name="FK_RoleHasPermission_Permission" Property="RoleHasPermissions" Kind="ManyToOneChild" Target="RoleHasPermission">
        <Column Name="PermissionId" />
      </Association>
      <PrimaryKey Name="PK_Permission">
        <Column Name="PermissionId" />
      </PrimaryKey>
      <Index Name="PK_Permission" Style="CLUSTERED" IsUnique="true">
        <Column Name="PermissionId" />
      </Index>
    </Table>
    <Table Name="RoleHasPermission" Property="RoleHasPermissions">
      <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="PermissionId" Type="System.Int32" DbType="Int NOT NULL" IsIdentity="true" Precision="10" Scale="255" />
      <Association Name="FK_RoleHasPermission_aspnet_Roles" Property="AspnetRoles" Kind="ManyToOneParent" Target="aspnet_Roles">
        <Column Name="RoleId" />
      </Association>
      <Association Name="FK_RoleHasPermission_Permission" Property="Permission" Kind="ManyToOneParent" Target="Permission">
        <Column Name="PermissionId" />
      </Association>
      <PrimaryKey Name="PK_RoleHasPermission_1">
        <Column Name="RoleId" />
        <Column Name="PermissionId" />
      </PrimaryKey>
      <Index Name="PK_RoleHasPermission_1" Style="CLUSTERED" IsUnique="true">
        <Column Name="RoleId" />
        <Column Name="PermissionId" />
      </Index>
    </Table>
    <Table Name="Group" Property="Groups">
      <Column Name="GroupId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(150) NOT NULL" Nullable="false" StringLength="150" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(500)" StringLength="500" />
      <Association Name="FK_Article_Group" Property="Articles" Kind="ManyToOneChild" Target="Article">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_Book_Group" Property="Books" Kind="ManyToOneChild" Target="Book">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_Company_Group" Property="Companies" Kind="ManyToOneChild" Target="Company">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_Event_Group" Property="Events" Kind="ManyToOneChild" Target="Event">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_JobOffer_Group" Property="JobOffers" Kind="ManyToOneChild" Target="JobOffer">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_Resource_Group" Property="Resources" Kind="ManyToOneChild" Target="Resource">
        <Column Name="GroupId" />
      </Association>
      <Association Name="FK_UserDetail_Group" Property="UserDetails" Kind="ManyToOneChild" Target="UserDetail">
        <Column Name="GroupId" />
      </Association>
      <PrimaryKey Name="PK_Group">
        <Column Name="GroupId" />
      </PrimaryKey>
      <Index Name="PK_Group" Style="CLUSTERED" IsUnique="true">
        <Column Name="GroupId" />
      </Index>
    </Table>
    <Table Name="aspnet_Paths" Property="AspnetPaths" Class="AspnetPath">
      <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" />
      <Column Name="PathId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="Path" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Column Name="LoweredPath" Type="System.String" DbType="NVarChar(256) NOT NULL" Nullable="false" StringLength="256" />
      <Association Name="FK__aspnet_Pa__Appli__6E01572D" Property="AspnetApplication" Kind="ManyToOneParent" Target="aspnet_Applications">
        <Column Name="ApplicationId" />
      </Association>
      <Association Name="FK__aspnet_Pe__PathI__73BA3083" Property="AspnetPersonalizationAllUser" Kind="OneToOneChild" Target="aspnet_PersonalizationAllUsers">
        <Column Name="PathId" />
      </Association>
      <Association Name="FK__aspnet_Pe__PathI__778AC167" Property="AspnetPersonalizationPerUsers" Kind="ManyToOneChild" Target="aspnet_PersonalizationPerUser">
        <Column Name="PathId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Paths__6D0D32F4">
        <Column Name="PathId" />
      </PrimaryKey>
      <Index Name="aspnet_Paths_index" Style="CLUSTERED" IsUnique="true">
        <Column Name="ApplicationId" />
        <Column Name="LoweredPath" />
      </Index>
      <Index Name="PK__aspnet_Paths__6D0D32F4" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="PathId" />
      </Index>
    </Table>
    <Table Name="aspnet_PersonalizationAllUsers" Property="AspnetPersonalizationAllUsers" Class="AspnetPersonalizationAllUser">
      <Column Name="PathId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="PageSettings" Type="System.Byte[]" DbType="Image NOT NULL" Nullable="false" UpdateCheck="Never" />
      <Column Name="LastUpdatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Association Name="FK__aspnet_Pe__PathI__73BA3083" Property="AspnetPath" Kind="OneToOneParent" Target="aspnet_Paths">
        <Column Name="PathId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Personali__72C60C4A">
        <Column Name="PathId" />
      </PrimaryKey>
      <Index Name="PK__aspnet_Personali__72C60C4A" Style="CLUSTERED" IsUnique="true">
        <Column Name="PathId" />
      </Index>
    </Table>
    <Table Name="aspnet_PersonalizationPerUser" Property="AspnetPersonalizationPerUsers" Class="AspnetPersonalizationPerUser">
      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsIdentity="true" />
      <Column Name="PathId" Type="System.Guid" DbType="UniqueIdentifier" Nullable="true" />
      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" Nullable="true" />
      <Column Name="PageSettings" Type="System.Byte[]" DbType="Image NOT NULL" Nullable="false" UpdateCheck="Never" />
      <Column Name="LastUpdatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" />
      <Association Name="FK__aspnet_Pe__PathI__778AC167" Property="AspnetPath" Kind="ManyToOneParent" Target="aspnet_Paths">
        <Column Name="PathId" />
      </Association>
      <Association Name="FK__aspnet_Pe__UserI__787EE5A0" Property="AspnetUser" Kind="ManyToOneParent" Target="aspnet_Users">
        <Column Name="UserId" />
      </Association>
      <PrimaryKey Name="PK__aspnet_Personali__75A278F5">
        <Column Name="Id" />
      </PrimaryKey>
      <Index Name="aspnet_PersonalizationPerUser_index1" Style="CLUSTERED" IsUnique="true">
        <Column Name="PathId" />
        <Column Name="UserId" />
      </Index>
      <Index Name="PK__aspnet_Personali__75A278F5" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="Id" />
      </Index>
      <Index Name="aspnet_PersonalizationPerUser_ncindex2" Style="NONCLUSTERED" IsUnique="true">
        <Column Name="UserId" />
        <Column Name="PathId" />
      </Index>
    </Table>
    <Table Name="EventArticleLevel" Property="EventArticleLevels">
      <Column Name="EventArticleLevelId" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsIdentity="true" IsAutoGen="true" IsReadOnly="false" Precision="10" Scale="255" />
      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" Nullable="false" StringLength="50" />
      <Association Name="FK_Article_EventArticleLevel" Property="Articles" Kind="ManyToOneChild" Target="Article">
        <Column Name="EventArticleLevelId" />
      </Association>
      <Association Name="FK_EventAgenda_EventArticleLevel" Property="EventAgendas" Kind="ManyToOneChild" Target="EventAgenda">
        <Column Name="EventArticleLevelId" />
      </Association>
      <PrimaryKey Name="PK_EventArticleLevel">
        <Column Name="EventArticleLevelId" />
      </PrimaryKey>
      <Index Name="PK_EventArticleLevel" Style="CLUSTERED" IsUnique="true">
        <Column Name="EventArticleLevelId" />
      </Index>
    </Table>
  </Schema>
</Database>